-
How can I get a correct average of several percentages that include 0%?
I have 5 different percentages and they are 0%, 0%, 0%, 0%, and 100%. I do not want the average to be 100% since there are four 0%. Is there a way to have the formula include the 0s and give me some …1 ·